CREATE PROCEDURE spSelectAllPersonsAndGroupsRelByGroupID
AS
BEGIN
		SELECT
		   tblPersons.PersonID,
		   tblPersons.FirstName,
		   tblPersons.LastName,
		   tblPersons.Phone,
		   tblPersons.Email,
		   tblPersons.Birthday,
		   tblGroups.GroupName,
		   tblPersons.Photo,
		   tblPersons.GroupID
		FROM
		   tblPersons,
		   tblGroups
		WHERE
		   tblPersons.GroupID = tblGroups.GroupID
		ORDER BY
		   tblPersons.PersonID
END
GO
